{\rtf1\ansi\ansicpg936\cocoartf1671\cocoasubrtf200
{\fonttbl\f0\froman\fcharset0 Times-Roman;\f1\fnil\fcharset134 STSongti-SC-Regular;}
{\colortbl;\red255\green255\blue255;}
{\*\expandedcolortbl;;}
\paperw11900\paperh16840\margl1440\margr1440\vieww28600\viewh18000\viewkind0
\pard\tx566\tx1133\tx1700\tx2267\tx2834\tx3401\tx3968\tx4535\tx5102\tx5669\tx6236\tx6803\pardirnatural\partightenfactor0

\f0\fs36 \cf0 1 
\f1 \'b0\'b2\'d7\'b0
\f0 MySQL\

\f1 \'b0\'b2\'d7\'b0
\f0 \
apt update\
apt install -y mysql-server mysql-client\

\f1 \
\'c1\'ac\'bd\'d3\
mysql -u root -p\
\
\'b7\'fe\'ce\'f1\'c3\'fc\'c1\'ee\
service mysql stop\
service mysql start\
service mysql restart\
\
\'c5\'e4\'d6\'c3\'ce\'c4\'bc\'fe\
/etc/mysql/my.conf.d/mysqld.cnf\
\'d7\'a2\'d2\'e2\'a3\'ba\
\'c8\'e7\'d0\'e8\'d4\'b6\'b3\'cc\'c1\'ac\'bd\'d3\'a3\'ac\'d4\'f2\'d7\'a2\'ca\'cd\'b5\'f4bind-address\'b5\'bd\'b1\'be\'b5\'d8\'c1\'ac\'bd\'d3\'b5\'c4\'d1\'a1\'cf\'ee\'a3\'bb\
innodb_buffer_pool_size\'cd\'a8\'b3\'a3\'c9\'e8\'d6\'c3\'ce\'aa\'b7\'fe\'ce\'f1\'c6\'f7\'d7\'dc\'c4\'da\'b4\'e6\'b5\'c470%\'d7\'f3\'d3\'d2\'a1\'a3\
\
\'bd\'f8\'c8\'ebmysql\'b7\'fe\'ce\'f1\'d6\'ae\'ba\'f3\'b5\'c4\'c3\'fc\'c1\'ee\
status\'c3\'fc\'c1\'ee\'a3\'ba\'b2\'e9\'d1\'af\'d7\'b4\'cc\'ac\
show variables like \'a1\'aemax_connections\'a1\'af; \'b2\'e9\'d1\'af\'d7\'ee\'b4\'f3\'c1\'ac\'bd\'d3\'ca\'fd\
show global status like \'a1\'aemax_used_connections\'a1\'af;\'b2\'e9\'d1\'af\'d2\'d1\'d3\'c3\'c1\'ac\'bd\'d3\'ca\'fd\
show variables like \'a1\'aeinnodb_buffer_pool_size\'a1\'af; \'b2\'e9\'d1\'afinnodb\'bb\'ba\'b4\'e6\'b3\'d8\'b4\'f3\'d0\'a1\
show status like \'a1\'aeinnodb_buffer_%\'a1\'af; \'b2\'e9\'d1\'afinnodb\'d4\'f6\'c9\'be\'b8\'c4\'b2\'e9\'b5\'c4\'b4\'ce\'ca\'fd\
\
\pard\tx566\tx1133\tx1700\tx2267\tx2834\tx3401\tx3968\tx4535\tx5102\tx5669\tx6236\tx6803\pardirnatural\partightenfactor0

\f0 \cf0 2 
\f1 \'d3\'c3\'bb\'a7\'ca\'da\'c8\'a8\
\pard\tx566\tx1133\tx1700\tx2267\tx2834\tx3401\tx3968\tx4535\tx5102\tx5669\tx6236\tx6803\pardirnatural\partightenfactor0
\cf0 \'b2\'e9\'bf\'b4mysql\'b5\'b1\'c7\'b0\'d3\'c3\'bb\'a7\
\'c1\'ac\'bd\'d3\'b2\'a2\'bd\'f8\'c8\'ebmysql\'b7\'fe\'ce\'f1\
use mysql;\'bd\'f8\'c8\'eb\'b5\'b1\'d6\'d0\'b5\'c4mysql\'ca\'fd\'be\'dd\'bf\'e2\
select host,user from mysql.user \'d1\'a1\'d4\'f1mysql\'ca\'fd\'be\'dd\'bf\'e2user\'b1\'ed\'d6\'d0\'b5\'c4host\'ba\'cduser\'d7\'d6\'b6\'ce\'bc\'b4\'bf\'c9\'b2\'e9\'bf\'b4\
\
\pard\tx566\tx1133\tx1700\tx2267\tx2834\tx3401\tx3968\tx4535\tx5102\tx5669\tx6236\tx6803\pardirnatural\partightenfactor0
\cf0 \'b4\'b4\'bd\'a8\'d4\'b6\'b3\'cc\'c1\'ac\'bd\'d3\'d3\'c3\'bb\'a7\
\pard\tx566\tx1133\tx1700\tx2267\tx2834\tx3401\tx3968\tx4535\tx5102\tx5669\tx6236\tx6803\pardirnatural\partightenfactor0
\cf0 grant all on *.* to root@\'a1\'b0%\'a1\'b1 identified by \'a1\'b0123456\'a1\'b1;\
all\'b1\'ed\'ca\'be\'cb\'f9\'d3\'d0\'c8\'a8\'cf\'de\
\'b5\'da\'d2\'bb\'b8\'f6*\'b1\'ed\'ca\'be\'ca\'fd\'be\'dd\'bf\'e2\'a3\'ac\'b5\'da\'b6\'fe\'b8\'f6*\'b1\'ed\'ca\'be\'ca\'fd\'be\'dd\'b1\'ed\'a3\'ac\'c1\'ac\'c6\'f0\'c0\'b4\'b1\'ed\'ca\'be\'b2\'bb\'cf\'de\'d6\'c6\'c8\'ce\'ba\'ce\'ca\'fd\'be\'dd\'bf\'e2\'ba\'cd\'ca\'fd\'be\'dd\'b1\'ed\
root\'b1\'ed\'ca\'be\'d3\'c3\'bb\'a7\
%\'b1\'ed\'ca\'be\'b2\'bb\'cf\'deip\'b5\'d8\'d6\'b7\'a3\'ac\'d2\'b2\'bf\'c9\'b8\'fc\'bb\'bb\'ce\'aa\'be\'df\'cc\'e5\'b5\'c4ip\'b5\'d8\'d6\'b7\
123456\'ce\'aa\'c3\'dc\'c2\'eb\
\'b4\'b4\'bd\'a8\'d6\'ae\'ba\'f3\'bf\'c9\'d2\'d4\'b2\'e9\'bf\'b4mysql\'b5\'b1\'c7\'b0\'d3\'c3\'bb\'a7\'ca\'c7\'b7\'f1\'b4\'b4\'bd\'a8\'b3\'c9\'b9\'a6\
\'d4\'b6\'b3\'cc\'c1\'ac\'bd\'d3\'ca\'b1\'a3\'ac\'d7\'a2\'d2\'e2\'cc\'ed\'bc\'d3\'b7\'fe\'ce\'f1\'c6\'f7\'b5\'c4\'b0\'b2\'c8\'ab\'d7\'e9\'b6\'cb\'bf\'da\'a3\'ac\'b7\'f1\'d4\'f2\'c1\'ac\'bd\'d3\'b2\'bb\'c9\'cf\
\
\pard\tx566\tx1133\tx1700\tx2267\tx2834\tx3401\tx3968\tx4535\tx5102\tx5669\tx6236\tx6803\pardirnatural\partightenfactor0

\f0 \cf0 3 
\f1 \'b1\'b8\'b7\'dd\
\pard\tx566\tx1133\tx1700\tx2267\tx2834\tx3401\tx3968\tx4535\tx5102\tx5669\tx6236\tx6803\pardirnatural\partightenfactor0
\cf0 \'b1\'b8\'b7\'dd\'ca\'fd\'be\'dd\
mysqldump -u root -p yourdb >backup.sql\
\
\'bb\'d6\'b8\'b4\'ca\'fd\'be\'dd\
Mysql -u root -p databasename<backup.sql\
\
mysql\'ca\'d6\'b2\'e1\
Https://dev.mysql.com/doc/refman/5.7/en/\
\
\
\
\
\
\
\

\f0 \
\
}